An Agent Based Etl System: Towards an Automatic Code Generation

The key of an effective management of enterprises is applying intelligent software tools to define decision analysis process, from data acquisition to recommended action, including an adaptive feedback. Decision support systems (DSS) have multiple data sources that contain valuable information that must be integrated and processed to allow the key business processes to have adaptive business intelligence. Conceptual modeling of decision support systems (DSS) should take into account some relevant aspects, such as the integration of external data, the behavior of the system environment, the available data sources and the emerging paradigm related to the intelligent systems. The aim of this work is to propose an approach based on model driven architectures, multi-agent systems (MAS) for DSS development. We are particularly interested in this work in developing a multi-agent based extraction, transformation and loading process (ETL), retrieving, extracting and integrating external data into Data Warehouses (DW) and generating automatically the DW code.